Chapter 6 Reading and Writing Data from an Excel Spreadsheet
6.2 Using the Import Wizard to Convert a Spreadsheet to a SAS Data Set
6.3 Creating an Excel Spreadsheet from a SAS Data Set
6.4 Using an Engine to Read an Excel Spreadsheet
6.5 Using the SAS Output Delivery System to Convert a SAS Data Set to an Excel Spreadsheet
6.1 Introduction
It is quite common to be given a Microsoft Office Excel spreadsheet as your data source. Luckily, SAS has several methods to easily convert a spreadsheet into a SAS data set. One way is to convert the spreadsheet into a comma-separated values (CSV) file and to read the file using INFILE statements (using the DSD option—see Chapter 3 for more information) and INPUT statements. ...
